Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
SchoolID (PK) | A unique retailer assigned identifier for an educational institution that a Worker may attend, as well as working for the Retailer. | ID_SCHL | Identity | integer | |
SchoolEndTime | The time of day the School finishes for students. | TM_END | Time | Time | |
SchoolGapMinutesCount | The number of minutes after the EndTime before a student can begin work at the retail enterprise. | QU_CNT_MIN_GAP | QuantityShortCountMinutes | decimal(4,0) | |
LatestSchoolDayTime | The latest a Worker who is enrolled at this School may work on the night before a school day. | TM_LTE_SCHL | Time | Time | |
LatestNonSchoolDayTime | The latest a Worker who is enrolled at this School may work on the night before a non-school day. | TM_LTE_NO_SCHL | Time | Time | |
PartyRoleAssignmentID (FK) | Token identifier for a PartyRoleAssignmentInstance. | ID_PRTY_RO_ASGMT | Identity | integer | PartyRoleAssignment(PA_RO_PRTY) |